<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Log Backup Subjobs Fail Because Archive Logs Are Automatically Cleaned">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002199967361.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000002199967429">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Log Backup Subjobs Fail Because Archive Logs Are Automatically Cleaned</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000002199967429"></a><a name="EN-US_TOPIC_0000002199967429"></a>

<h1 class="topictitle1">Log Backup Subjobs Fail Because Archive Logs Are Automatically Cleaned</h1>
<div><div class="section"><h4 class="sectiontitle">Symptom</h4><p>A GaussDB T log backup job fails and a message indicating an internal error is displayed in the job details on the OceanProtect WebUI. Obtain the <strong>database_plugin.log</strong> files of all nodes from the host where the client is installed and the error is reported, and query the error information in logs. The following shows an example of the log information.</p>
<p><span><img src="en-us_image_0000002200001873.png"></span></p>
</div>
<div class="section"><h4 class="sectiontitle">Possible Cause</h4><p>GaussDB T automatically cleans archive logs based on the parameter settings. After archive logs are cleaned, the following abnormal scenarios may occur based on the number of cleaned archive logs:</p>
<ul><li>Archive logs generated between log backup A and the next full backup B are cleaned. The start of the copy time of log backup C is the copy time of full backup B. The copy time of log backup C is discontinuous with that of log backup A.</li><li>If archive logs generated after full backup A are cleaned, log backup B will fail next time.</li></ul>
</div>
<div class="section"><h4 class="sectiontitle">Troubleshooting</h4><ul><li><strong>Method 1:</strong> Full backup<ol><li>In the SLA, enable automatically switching to full backup after a log backup fails. After this function is enabled, the next log backup will be automatically switched to full backup after a log backup fails.</li></ol>
</li></ul>
<ul><li><strong>Method 2:</strong> Cleaning fewer archive logs<ol><li>Log in to the GaussDB T database of the target host.</li><li>Run the following command:<pre class="screen"><strong>ALTER SYSTEM SET </strong>PARAMETER<strong>=</strong>'VALUE'</pre>
<div class="p"><strong>PARAMETER</strong> can be replaced with the following three parameters. Set <strong>VALUE</strong> based on the actual requirements. For details about the following parameter meanings, see GaussDB T official documents.<ul><li><strong>ARCH_CLEAN_UPPER_LIMIT</strong>: The default value is <strong>85%</strong>.</li><li><strong>ARCH_CLEAN_LOWER_LIMIT</strong>: The default value is <strong>15%</strong>.</li><li><strong>MAX_ARCH_FILES_SIZE</strong>: The default value is <strong>16 GB</strong>.</li></ul>
</div>
</li></ol>
</li></ul>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000002199967361.html">FAQs</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>